{
  "statement":"select \n\tc.sales_bill_no\nfrom test.join_eliminate_nulls_tbl1 as c\nleft join test.join_eliminate_nulls_tbl0 e ON c.CUSTOMER_ID \u003d e.TID\nwhere 1\u003d1\nand case (select u.type from test.join_eliminate_nulls_tbl2 u  where concat(\u0027ocms_\u0027,lower(u.LOGIN_NAME))\u003dlower(\u0027ocms_fengyang56\u0027) limit 1) \t\t\twhen \u00271\u0027 then  concat(\u0027ocms_\u0027,e.name)\u003d\u0027ocms_fengyang56\u0027 \t\t\twhen \u00270\u0027 then  1\u003d1      \t\t\telse  1\u003d2 end\nlimit 10",
  "table_meta":{
    "test.join_eliminate_nulls_tbl0":"CREATE EXTERNAL TABLE `join_eliminate_nulls_tbl0` (\n  `id` varchar(124) NOT NULL COMMENT \"id\",\n  `application_id` varchar(105) NOT NULL COMMENT \"  id\",\n  `org_id` varchar(124) NULL COMMENT \"    id\",\n  `parent_id` varchar(124) NULL COMMENT \"   \",\n  `name` varchar(160) NOT NULL COMMENT \"     \",\n  `code` varchar(124) NOT NULL COMMENT \"     \",\n  `level` int(11) NULL COMMENT \"  1:    2  3:  \",\n  `mobile` varchar(110) NULL COMMENT \"  \",\n  `contact` varchar(120) NULL COMMENT \"    \",\n  `tax_no` varchar(110) NULL COMMENT \"   \",\n  `permit_code` varchar(110) NULL COMMENT \"   \",\n  `business_license` varchar(110) NULL COMMENT \"   \",\n  `print_sign` varchar(260) NULL COMMENT \"   \",\n  `remarks` varchar(315) NULL COMMENT \"  \",\n  `del_flag` varchar(1) NOT NULL COMMENT \"     0  ，1  \",\n  `updated_by` varchar(124) NULL COMMENT \"   \",\n  `created_by` varchar(124) NULL COMMENT \"   \",\n  `opt_counter` int(11) NOT NULL COMMENT \"    \",\n  `created_date` datetime NOT NULL COMMENT \"    \",\n  `updated_date` datetime NOT NULL COMMENT \"   \",\n  `is_take_by_self` int(11) NOT NULL COMMENT \"    :1-  0- \",\n  `is_billing` int(11) NOT NULL COMMENT \"    :1-  0- \",\n  `region_code` varchar(105) NULL COMMENT \"    \",\n  `is_used_pallet` int(11) NULL COMMENT \"    :0-   1-    2-   \",\n  `is_tray` int(11) NULL COMMENT \"      :0-  1- \",\n  `is_pause_billing` int(11) NULL COMMENT \"    ：1-  ，       \",\n  `is_tax` int(11) NULL COMMENT \"     :1-  0- \",\n  `is_vip` int(11) NULL COMMENT \"  vip:1-  0- \",\n  `channel` varchar(105) NULL COMMENT \"  \",\n  `is_actived` int(11) NULL COMMENT \"      \",\n  `region` varchar(92) NULL COMMENT \"  \",\n  `address` varchar(315) NULL COMMENT \"  \",\n  `is_cooperate` int(11) NULL COMMENT \"      :1   0   \",\n  `tid` bigint(20) NOT NULL COMMENT \"tid\",\n  `take_type` varchar(160) NULL COMMENT \"    \",\n  `billing_type` varchar(160) NULL COMMENT \"    \",\n  `post_code` varchar(160) NULL COMMENT \"    \",\n  `post_name` varchar(160) NULL COMMENT \"    \",\n  `post_staff` varchar(160) NULL COMMENT \"     \",\n  `enterprise_org` varchar(160) NULL COMMENT \"      \",\n  `eft_status` varchar(160) NULL COMMENT \"    \",\n  `account_validity_date` datetime NULL COMMENT \"     \",\n  `sales_management_org` varchar(160) NULL COMMENT \"        \",\n  `reg_address` varchar(160) NULL COMMENT \"    \",\n  `opening_bank` varchar(160) NULL COMMENT \"   \",\n  `opening_bank_code` varchar(160) NULL COMMENT \"     \",\n  `erp_code` varchar(160) NULL COMMENT \"erp  \",\n  `contract_rebates` varchar(160) NULL COMMENT \"      \",\n  `golden_tax_customer_name` varchar(160) NULL COMMENT \"      \",\n  `invoice_type` varchar(160) NULL COMMENT \"    \",\n  `transport_type` varchar(160) NULL COMMENT \"    \",\n  `golden_tax_number` varchar(160) NULL COMMENT \"    \",\n  `golden_tax_opening_bank` varchar(160) NULL COMMENT \"     \",\n  `golden_tax_contact` varchar(160) NULL COMMENT \"      \",\n  `golden_tax_bank_account` varchar(160) NULL COMMENT \"      \",\n  `golden_tax_address` varchar(160) NULL COMMENT \"    \",\n  `is_internal_customer` varchar(160) NULL COMMENT \"      \",\n  `return_empty_type` varchar(160) NULL COMMENT \"    \",\n  `is_return_empty` int(11) NULL COMMENT \"      \",\n  `province` varchar(160) NULL COMMENT \"  \",\n  `fms_is_netincome` int(11) NULL COMMENT \"       \",\n  `customer_type` varchar(160) NULL COMMENT \"      1，   2，  \",\n  `goldentax_customer_name` varchar(160) NULL COMMENT \"      \",\n  `goldentax_phone_no` varchar(160) NULL COMMENT \"      \",\n  `email` varchar(160) NULL COMMENT \"  \",\n  `contract_bond` varchar(124) NULL COMMENT \"       \",\n  `salesman` varchar(124) NULL COMMENT \"   \",\n  `cargo_fille_rate` varchar(76) NULL COMMENT \"    \",\n  `is_show_netincome` int(11) NULL COMMENT \"       （ fms_is_netincome  ，  ）\",\n  `relate__company` varchar(160) NULL COMMENT \"    \",\n  `customer_category` int(11) NULL COMMENT \"    ：1-   ；2：   \",\n  `is_direct_invoice` bigint(20) NULL COMMENT \"      \",\n  `is_bridge_retreat` varchar(120) NULL COMMENT \"        ，   n\",\n  `big_type` bigint(20) NULL COMMENT \"       ：0：    ，1：   ，2：   \",\n  `zzrelmapatn` varchar(110) NULL COMMENT \"   code\"\n) ENGINE\u003dMYSQL \nCOMMENT \"   \"\nPROPERTIES (\n\"host\" \u003d \"10.0.180.197\",\n\"port\" \u003d \"3316\",\n\"user\" \u003d \"root\",\n\"password\" \u003d \"\",\n\"database\" \u003d \"test\",\n\"table\" \u003d \"join_eliminate_nulls_tbl0\"\n);",
    "test.join_eliminate_nulls_tbl1":"CREATE TABLE `join_eliminate_nulls_tbl1` (\n  `tid` bigint(20) NOT NULL COMMENT \"  \",\n  `created_date` datetime NOT NULL COMMENT \"    \",\n  `sales_bill_no` varchar(76) NOT NULL COMMENT \"    \",\n  `region_code` varchar(70) NOT NULL COMMENT \"    \",\n  `customer_id` bigint(20) NULL COMMENT \"   id\",\n  `customer_name` varchar(160) NULL COMMENT \"    \",\n  `corporation_id` bigint(20) NULL COMMENT \"    id\",\n  `corporation` varchar(160) NULL COMMENT \"      \",\n  `factory_id` bigint(20) NULL COMMENT \"    id\",\n  `factory` varchar(160) NULL COMMENT \"    \",\n  `carrier_id` bigint(20) NULL COMMENT \"   id\",\n  `carrier` varchar(160) NULL COMMENT \"   \",\n  `truck_no` varchar(110) NULL COMMENT \"     \",\n  `address` varchar(260) NULL COMMENT \"    \",\n  `money_primage_sum` decimal64(14, 2) NULL COMMENT \"  \",\n  `customer_address_id` bigint(20) NULL COMMENT \"    id\",\n  `customer_address_md` varchar(160) NULL COMMENT \"      \",\n  `money_beer_sum` decimal64(14, 2) NULL COMMENT \"    \",\n  `money_bail_sum` decimal64(14, 2) NULL COMMENT \"     \",\n  `money_foregift_sum` decimal64(14, 2) NULL COMMENT \"     \",\n  `transportation_expenses_sum` decimal64(14, 2) NULL COMMENT \"    \",\n  `money_geton_sum` decimal64(14, 2) NULL COMMENT \"    \",\n  `money_advance_sum` decimal64(14, 2) NULL COMMENT \"     \",\n  `money_fact_total_sum` decimal64(14, 2) NULL COMMENT \"     \",\n  `money_self` decimal64(16, 6) NULL COMMENT \"       \",\n  `discount_sum` decimal64(14, 2) NULL COMMENT \"    \",\n  `money_tick_sum` decimal64(14, 2) NULL COMMENT \"    \",\n  `salesman` varchar(110) NULL COMMENT \"   \",\n  `take_type_name` varchar(92) NULL COMMENT \"    \",\n  `is_arrearage` int(11) NULL COMMENT \"    \",\n  `is_settled` int(11) NULL COMMENT \"    \",\n  `is_sendcar` int(11) NULL COMMENT \"    \",\n  `is_used_pallet` int(11) NULL COMMENT \"    \",\n  `shopping_cost_type` tinyint(4) NULL COMMENT \"    \",\n  `take_byself` int(11) NULL COMMENT \"    \",\n  `is_back_empty` int(11) NULL COMMENT \"    \",\n  `is_send_order` int(11) NULL COMMENT \"  -          ::  :0(0:  , 1:  )\",\n  `is_send_settle` int(11) NULL COMMENT \"  -        ::  :0(0:  , 1:  )\",\n  `is_send_receiving` int(11) NULL COMMENT \"  -        ::  :0(0:  , 1:  )\",\n  `tray_num` int(11) NULL COMMENT \"     \",\n  `box_num` decimal64(16, 6) NULL COMMENT \"   \",\n  `source_channel` int(11) NULL COMMENT \"    :0：   ，1：web ，2：    \",\n  `is_tray` int(11) NULL COMMENT \"    ,1:   ,0:   \",\n  `plan_shipments_time` datetime NULL COMMENT \"\",\n  `is_cancel_out` varchar(120) NOT NULL COMMENT \"    \",\n  `print_times` smallint(6) NULL COMMENT \"    \",\n  `print_date` datetime NULL COMMENT \"      \",\n  `make_date` datetime NULL COMMENT \"    \",\n  `make_join_eliminate_nulls_tbl2` varchar(124) NULL COMMENT \"   \",\n  `gate_id` bigint(20) NULL COMMENT \"  id\",\n  `gate_name` varchar(315) NULL COMMENT \"    \",\n  `is_cancel_out_order` varchar(120) NULL COMMENT \"      \",\n  `import_flag` varchar(120) NULL COMMENT \"      \",\n  `is_cross_bridge` varchar(120) NULL COMMENT \"          \",\n  `cancel_desc` varchar(315) NULL COMMENT \"    \",\n  `direct_flag` varchar(62) NULL COMMENT \"    \",\n  `version` double NOT NULL COMMENT \"  \",\n  `remarks` varchar(315) NULL COMMENT \"  \",\n  `del_flag` varchar(120) NOT NULL COMMENT \"    \",\n  `created_by` varchar(124) NOT NULL COMMENT \"   id\",\n  `created_join_eliminate_nulls_tbl2` varchar(124) NOT NULL COMMENT \"     \",\n  `opt_counter` int(11) NOT NULL COMMENT \"   \",\n  `updated_by` varchar(124) NULL COMMENT \"   id\",\n  `updated_join_eliminate_nulls_tbl2` varchar(124) NULL COMMENT \"     \",\n  `updated_date` datetime NULL COMMENT \"    \",\n  `is_test` varchar(120) NOT NULL COMMENT \"      \",\n  `process_type_name` varchar(92) NULL COMMENT \"        \",\n  `pickup_code` varchar(72) NULL COMMENT \"   \",\n  `storehouse_group_id` bigint(20) NULL COMMENT \"  id\",\n  `storehouse_group_code` varchar(124) NULL COMMENT \"  code\",\n  `storehouse_group_name` varchar(124) NULL COMMENT \"    \",\n  `relation_sales_bill_no` varchar(76) NULL COMMENT \"      \",\n  `un_force_print` varchar(120) NULL COMMENT \"       \",\n  `nka_type` varchar(70) NULL COMMENT \"  nka  \",\n  `remote_code` varchar(92) NULL COMMENT \"      \",\n  `direct_so1_flag` varchar(62) NOT NULL COMMENT \"  so1    \",\n  `object_type` varchar(124) NULL COMMENT \"    \",\n  `object_code` varchar(188) NULL COMMENT \"    \",\n  `orig_sales_no` varchar(92) NULL COMMENT \"     \",\n  `cross_bridge_tuiya` varchar(120) NULL COMMENT \"      ：y  n  \",\n  `chargeoff_return` varchar(120) NULL COMMENT \"        ：y n \",\n  `direct_so2_result` varchar(315) NULL COMMENT \"      so2    \",\n  `remote_region_code` varchar(70) NULL COMMENT \"         )\",\n  `remote_factory_id` bigint(20) NULL COMMENT \"      id\",\n  `apply_bill_no` varchar(90) NULL COMMENT \"     lh\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`tid`, `created_date`)\nCOMMENT \"     header \"\nPARTITION BY RANGE(`created_date`)\n(PARTITION p202001 VALUES [(\u00272020-01-01 00:00:00\u0027), (\u00272020-02-01 00:00:00\u0027)),\nPARTITION p202002 VALUES [(\u00272020-02-01 00:00:00\u0027), (\u00272020-03-01 00:00:00\u0027)),\nPARTITION p202003 VALUES [(\u00272020-03-01 00:00:00\u0027), (\u00272020-04-01 00:00:00\u0027)),\nPARTITION p202004 VALUES [(\u00272020-04-01 00:00:00\u0027), (\u00272020-05-01 00:00:00\u0027)),\nPARTITION p202005 VALUES [(\u00272020-05-01 00:00:00\u0027), (\u00272020-06-01 00:00:00\u0027)),\nPARTITION p202006 VALUES [(\u00272020-06-01 00:00:00\u0027), (\u00272020-07-01 00:00:00\u0027)),\nPARTITION p202007 VALUES [(\u00272020-07-01 00:00:00\u0027), (\u00272020-08-01 00:00:00\u0027)),\nPARTITION p202008 VALUES [(\u00272020-08-01 00:00:00\u0027), (\u00272020-09-01 00:00:00\u0027)),\nPARTITION p202009 VALUES [(\u00272020-09-01 00:00:00\u0027), (\u00272020-10-01 00:00:00\u0027)),\nPARTITION p202010 VALUES [(\u00272020-10-01 00:00:00\u0027), (\u00272020-11-01 00:00:00\u0027)),\nPARTITION p202011 VALUES [(\u00272020-11-01 00:00:00\u0027), (\u00272020-12-01 00:00:00\u0027)),\nPARTITION p202012 VALUES [(\u00272020-12-01 00:00:00\u0027), (\u00272021-01-01 00:00:00\u0027)),\nPARTITION p202101 VALUES [(\u00272021-01-01 00:00:00\u0027), (\u00272021-02-01 00:00:00\u0027)),\nPARTITION p202102 VALUES [(\u00272021-02-01 00:00:00\u0027), (\u00272021-03-01 00:00:00\u0027)),\nPARTITION p202103 VALUES [(\u00272021-03-01 00:00:00\u0027), (\u00272021-04-01 00:00:00\u0027)),\nPARTITION p202104 VALUES [(\u00272021-04-01 00:00:00\u0027), (\u00272021-05-01 00:00:00\u0027)),\nPARTITION p202105 VALUES [(\u00272021-05-01 00:00:00\u0027), (\u00272021-06-01 00:00:00\u0027)),\nPARTITION p202106 VALUES [(\u00272021-06-01 00:00:00\u0027), (\u00272021-07-01 00:00:00\u0027)),\nPARTITION p202107 VALUES [(\u00272021-07-01 00:00:00\u0027), (\u00272021-08-01 00:00:00\u0027)),\nPARTITION p202108 VALUES [(\u00272021-08-01 00:00:00\u0027), (\u00272021-09-01 00:00:00\u0027)),\nPARTITION p202109 VALUES [(\u00272021-09-01 00:00:00\u0027), (\u00272021-10-01 00:00:00\u0027)),\nPARTITION p202110 VALUES [(\u00272021-10-01 00:00:00\u0027), (\u00272021-11-01 00:00:00\u0027)),\nPARTITION p202111 VALUES [(\u00272021-11-01 00:00:00\u0027), (\u00272021-12-01 00:00:00\u0027)),\nPARTITION p202112 VALUES [(\u00272021-12-01 00:00:00\u0027), (\u00272022-01-01 00:00:00\u0027)),\nPARTITION p202201 VALUES [(\u00272022-01-01 00:00:00\u0027), (\u00272022-02-01 00:00:00\u0027)),\nPARTITION p202202 VALUES [(\u00272022-02-01 00:00:00\u0027), (\u00272022-03-01 00:00:00\u0027)),\nPARTITION p202203 VALUES [(\u00272022-03-01 00:00:00\u0027), (\u00272022-04-01 00:00:00\u0027)),\nPARTITION p202204 VALUES [(\u00272022-04-01 00:00:00\u0027), (\u00272022-05-01 00:00:00\u0027)),\nPARTITION p202205 VALUES [(\u00272022-05-01 00:00:00\u0027), (\u00272022-06-01 00:00:00\u0027)),\nPARTITION p202206 VALUES [(\u00272022-06-01 00:00:00\u0027), (\u00272022-07-01 00:00:00\u0027)),\nPARTITION p202207 VALUES [(\u00272022-07-01 00:00:00\u0027), (\u00272022-08-01 00:00:00\u0027)),\nPARTITION p202208 VALUES [(\u00272022-08-01 00:00:00\u0027), (\u00272022-09-01 00:00:00\u0027)),\nPARTITION p202209 VALUES [(\u00272022-09-01 00:00:00\u0027), (\u00272022-10-01 00:00:00\u0027)),\nPARTITION p202210 VALUES [(\u00272022-10-01 00:00:00\u0027), (\u00272022-11-01 00:00:00\u0027)),\nPARTITION p202211 VALUES [(\u00272022-11-01 00:00:00\u0027), (\u00272022-12-01 00:00:00\u0027)),\nPARTITION p202212 VALUES [(\u00272022-12-01 00:00:00\u0027), (\u00272023-01-01 00:00:00\u0027)),\nPARTITION p202301 VALUES [(\u00272023-01-01 00:00:00\u0027), (\u00272023-02-01 00:00:00\u0027)),\nPARTITION p202302 VALUES [(\u00272023-02-01 00:00:00\u0027), (\u00272023-03-01 00:00:00\u0027)))\nDISTRIBUTED BY HASH(`tid`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"dynamic_partition.enable\" \u003d \"true\",\n\"dynamic_partition.time_unit\" \u003d \"MONTH\",\n\"dynamic_partition.time_zone\" \u003d \"Asia/Shanghai\",\n\"dynamic_partition.start\" \u003d \"-2147483648\",\n\"dynamic_partition.end\" \u003d \"3\",\n\"dynamic_partition.prefix\" \u003d \"p\",\n\"dynamic_partition.buckets\" \u003d \"1\",\n\"dynamic_partition.start_day_of_month\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "test.join_eliminate_nulls_tbl2":"CREATE TABLE `join_eliminate_nulls_tbl2` (\n  `id` varchar(124) NOT NULL COMMENT \"id\",\n  `application_id` varchar(105) NOT NULL COMMENT \"  id\",\n  `login_name` varchar(160) NOT NULL COMMENT \"   \",\n  `password` varchar(160) NOT NULL COMMENT \"  \",\n  `ldap_password` varchar(160) NULL COMMENT \"ldap    \",\n  `no` varchar(160) NULL COMMENT \"   \",\n  `name` varchar(160) NOT NULL COMMENT \"    \",\n  `email` varchar(260) NULL COMMENT \"    \",\n  `phone` varchar(260) NULL COMMENT \"  \",\n  `mobile` varchar(260) NULL COMMENT \"  \",\n  `login_ip` varchar(160) NULL COMMENT \"   \",\n  `login_date` datetime NULL COMMENT \"      \",\n  `sex` varchar(105) NULL COMMENT \"  \",\n  `type` varchar(105) NOT NULL COMMENT \"   0      1     \",\n  `sub_type` varchar(105) NULL COMMENT \"       0     1   \",\n  `client_type` varchar(105) NULL COMMENT \"     null      0    1     2   \",\n  `big_type` varchar(105) NULL COMMENT \"     ：0--    ；1--   ；2--         \",\n  `client_id` varchar(105) NULL COMMENT \"   id\",\n  `client_tid` bigint(20) NULL COMMENT \"   tid\",\n  `big_customer_code` varchar(110) NULL COMMENT \"        \",\n  `is_ldap` tinyint(4) NULL COMMENT \"  ldap    :0- ;1- \",\n  `remarks` varchar(315) NULL COMMENT \"  \",\n  `errors` int(11) NULL COMMENT \"    \",\n  `errors_max` int(11) NULL COMMENT \"      \",\n  `locked` varchar(105) NULL COMMENT \"    \",\n  `is_registed` varchar(120) NULL COMMENT \"    \",\n  `start_date` datetime NULL COMMENT \"     \",\n  `end_date` datetime NULL COMMENT \"     \",\n  `del_flag` varchar(1) NOT NULL COMMENT \"     0  ，1  \",\n  `opt_counter` int(11) NOT NULL COMMENT \"\",\n  `created_date` datetime NULL COMMENT \"    \",\n  `created_by` varchar(124) NULL COMMENT \"   \",\n  `updated_date` datetime NULL COMMENT \"    \",\n  `updated_by` varchar(124) NULL COMMENT \"   \",\n  `region_code` varchar(105) NULL COMMENT \"    \",\n  `front_id` bigint(20) NOT NULL COMMENT \"  id\",\n  `client_name` varchar(160) NULL COMMENT \"     \",\n  `client_code` varchar(110) NULL COMMENT \"     \",\n  `region` varchar(92) NULL COMMENT \"     \",\n  `sub_join_eliminate_nulls_tbl2_type` varchar(70) NULL COMMENT \"   \",\n  `tid` bigint(20) NULL COMMENT \"   \",\n  `join_eliminate_nulls_tbl2_flag` int(11) NULL COMMENT \"       ：1:    ，0    \",\n  `is_salesman` varchar(61) NULL COMMENT \"   \",\n  `salesman_id` varchar(124) NULL COMMENT \"   \",\n  `dept` varchar(315) NULL COMMENT \"  \"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"  \"\nDISTRIBUTED BY HASH(`id`) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);"
  },
  "table_row_count":{

  },
  "session_variables":"{\"enable_resource_group\":false,\"enable_show_all_variables\":false,\"cbo_cte_reuse\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"character_set_results\":\"utf8\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"enable_local_shuffle_agg\":true,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648,\"cbo_max_reorder_node_use_dp\":10,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"is_report_success\":false,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"query_timeout\":300,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"broadcast_right_table_scale_factor\":10,\"disable_streaming_preaggregations\":false,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"statistic_collect_parallel\":1,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_exchange_pass_through\":true,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics":{
  },
  "be_number":3,
  "exception":[],
  "version":"",
  "commit_version":""
}